Spreadsheet Pane Column Definitions

The Spreadsheet pane of the Project view displays a set of standard columns.

Use the Insert Column dialog box and the Edit Column dialog box to change fields in the Spreadsheet pane.

Column Description Formula
% Complete This column displays the manually entered percent complete used to calculate earned value for work packages with a progress technique of Percent Complete. N/A
% Spent This column displays the percentage of the forecast spent.

(Actuals / BAC) * 100

Actual Finish This column displays the actual finish date of the control account or work package. N/A
Actual Rate This column displays the actual rate.

Actuals / Actuals Hours

Actual Start This column displays the actual start date of the control account or work package. N/A
Actuals This column displays the total actual currency value of the control account or work package. The Update Totals utility populates the value in the table. N/A
Apportioned CaWP Uid This column displays the UID for the work package stored in the Apportioned to field. N/A
Apportioned to This column displays the work package to which the budget for the referenced work package is apportioned. N/A
Assignment % Complete This column displays the percentage of work that has been completed for the Earned Value class to which the resource is assigned. N/A
BAC This column displays the budget at completion or the resource total. N/A
Baseline Finish This column displays the baseline finish date that defines the last date of the control account or work package. N/A
Baseline Start This column displays the baseline start date that defines the initial status date for the control account or work package. N/A
Budget This column displays the total currency budget value of the control account or work package. The Update Totals utility populates the value in the column. N/A
Budget Rate This column displays the budget rate.

Budget / Budget Hours

Ca[1-3]Id This column displays the control account field names. N/A
Calculated % Complete This column displays the percentage of the work that has been completed, which is calculated using the formula Earned/BAC * 100. The value in the column is populated when you run the Calculate Progress process or when you manually edit or create the Earned Value class of a resource assignment and run the Update Totals process.

(Earned / BAC) * 100

CAM This column displays the Control Account Manager (CAM) code attached to the control account. N/A
CAWPUid This is used internally by Cobra. N/A
CI Batch This is used internally by Cobra. N/A
Class This column displays the class associated with the resource. N/A
Class Description This column displays a brief description of the class associated with the resource. N/A
Control Account Codes [1-9] This column displays the control account codes. N/A
CPI This column displays the Cost Performance Index, which is an index of the contract performance.

Earned / Actuals

CPI Performance This column displays the CPI Performance.

Actuals/ Earned

Current Period Actuals This column displays the current period actual currency value of the control account or work package. The Update Totals utility populates the value in the table. N/A
Current Period Budget This column displays the current period budget value of the control account or work package. The Update Totals utility populates the value in the table. N/A
Current Period Hours Actuals This column displays the current period actuals value in hours of the control account or work package. The Update Totals utility populates the value in the table. N/A
Current Period Hours Budget This column displays the current period budget value in hours of the control account or work package. The Update Totals utility populates the value in the table. N/A
Current Period Hours Progress This column displays the current period earned value in hours of the control account or work package. The Update Totals utility populates the value in the table. N/A
Current Period Progress This column displays the current period earned value of the control account or work package. The Update Totals utility populates the value in the table. N/A
CV This column displays the Cost Variance in dollars.

Earned - Actuals

CV % This column displays the Cost Variance percentage.

((Earned - Actuals) / Earned) * 100

Description This column displays a brief description of the control account or work package. N/A
EAC This column displays the total Estimate At Complete currency value based on the cost set EAC. The Update Totals utility populates the value in the table. N/A
Early Finish This column displays the early finish date for the control account or work package. N/A
Early Start This column displays the early start date for the control account or work package. N/A
Forecast Finish This column displays the forecast finish date of the control account or work package. N/A
Forecast Start This column displays the initial status date for the control account or work package. N/A
Hours % Complete This column displays the percentage of the work that has been completed.

(Earned Hours / BAC Hours) * 100

Hours % Spent This column displays the percentage of the budget spent.

(Actuals Hours / BAC Hours) * 100

Hours Actuals This column displays the total actual values in hours. N/A
Hours BAC This column displays the budget at completion in hours. N/A
Hours Budget This column displays the budget values in hours. N/A
Hours CPI This column displays the Cost Performance Index in hours.

Earned Hours / Actuals Hours

Hours CPI Performance This column displays the CPI Performance in hours.

Actuals Hours/Earned Hours

Hours CV This column displays the Cost Variance in hours.

Earned Hours - Actuals Hours

Hours CV % This column displays the Cost Variance percentage.

((Earned Hours - Actuals Hours) / Earned Hours) * 100

Hours EAC This column displays the total Estimate At Complete currency value in hours. N/A
Hours iEAC This column displays the independent Estimate At Complete in hours.

Actuals Hours + ((1 / CPI Hours) * (BAC Hours - Earned Hours))

Hours iEAC2 This column displays the independent Estimate At Complete in hours.

Actuals Hours + ((1 / (CPI Hours * SPI Hours)) * (BAC Hours - Earned Hours))

Hours Progress This column displays the total earned currency value in hours. N/A
Hours SPI This column displays the Schedule Performance Index (SPI) in hours.

Earned Hours / Budget Hours

Hours SV This column displays the Schedule Variance (SV) in hours.

Earned Hours - Budget Hours

Hours SV % This column displays the Schedule Variance (SV) percentage.

((Earned Hours - Budget Hours) / Budget Hours) * 100

Hours TCPIBAC This column displays the To Complete Performance Index for the budget at complete in hours.

(BAC Hours - Earned Hours) / (BAC Hours - Actuals Hours)

Hours TCPIEAC This column displays the To Complete Performance Index for the projected estimate at complete in hours.

(BAC Hours - Earned Hours) / (EAC Hours - Actuals Hours)

Hours VAC This column displays the Variance At Complete (VAC) in hours.

BAC Hours - EAC Hours

Hours VAC % This column displays the Variance At Complete (VAC) percentage.

((BAC Hours - EAC Hours) / BAC Hours) * 100

Hours Variance This column displays the Variance in hours.

Budget Hours - Actuals Hours

iEAC This column displays the independent Estimate At Complete.

Actuals + ((1 / CPI) * (BAC - Earned))

iEAC2 This column displays the independent Estimate at Complete.

Actuals + ((1 / (CPI * SPI)) * (BAC - Earned))

Last Update This column displays the date when the control account or work package details were last updated. N/A
Late Finish This column displays the late finish date for the control account or work package. N/A
Late Start This column displays the late start date for the control account or work package. N/A
Non Labor EAC This column displays the EAC value for resources that do not have an hours result. This field is used in the scale EAC currency option when both hours and currency are selected. N/A
OP Batch This is used internally Cobra. N/A
Pending Finish This column displays the pending finish date of the control account or work package. N/A
Pending Start This column displays the pending start date of the control account or work package. N/A
Performance Factor This column displays the performance factor value, usually based on performance to date, which is divided into the budgeted cost of work remaining to arrive at an Estimate To Complete (ETC). N/A
Progress This column displays the total earned currency value of the control account or work package. The Update Totals utility populates the value in the table. N/A
Progress Technique This column displays the progress technique assigned to the work package. N/A
Project This column displays the name of the project. N/A
Resource This column displays resource assignment for the selected cost set or class type. N/A
Resource Assignment Codes [1-9] This column displays resource assignment codes. N/A
Resource Description This column displays a brief description of the resource. N/A
Sequence This column is used internally by Cobra.
SPI This column displays the Schedule Performance Index.

Earned / Budget

Spread Curve

This column displays the spread curve name for the budget or forecast resource assignments. If there is no assigned spread curve, or if the resource assignment is manually spread or adjusted, this column displays Manual.

For other types of resource assignments, this column is blank.

N/A
Start Percent This column displays the opening percent complete for work packages that use the user-defined progress technique. N/A
Status This column displays the status of the selected control account or work package. N/A
SV This column displays the Schedule Variance in dollars

Earned - Budget

SV % This column displays the Schedule Variance percentage.

((Earned - Budget) / Budget) * 100

TCPIBAC This column displays the To Complete performance index for the budget at complete.

(BAC - Earned) / (BAC - Actuals)

TCPIEAC This column displays the To Complete Performance Index for the projected estimate at complete.

(BAC - Earned) / (EAC - Actuals)

Total This column displays the current total for each of the results over the life of the project. N/A
Uid This column displays the unique ID for the row. N/A
Units This column displays how the result is measured. For example, a unit of measurement might be dollars, or it might be tons. N/A
Units Complete This column displays the number of units completed. N/A
Units To Do This column displays the number of units that remain to be completed, which is available only if you selected the Units Complete progress technique. N/A
User This column displays the individual who is currently accessing the project. N/A
User Character Fields [1-10] This column displays the character fields that can be used for display in the view, or can be added as tags in the reports.
Note: You must first run the required script to display User Character Fields [6-10]. Refer to Additional User Fields for instructions on how to configure Cobra to use these additional fields.
N/A
User Date Fields [1-10] This column displays the date fields that can be used for display in the view, or can be added as tags in the reports.
Note: You must first run the required script to display User Date Fields [6-10]. Refer to Additional User Fields for instructions on how to configure Cobra to use these additional fields.
N/A
User Numeric Fields [1-10] This column displays the numeric fields that can be used for display in the view, or can be added as tags in the reports.
Note: You must first run the required script to display User Numeric Fields [6-10]. Refer to Additional User Fields for instructions on how to configure Cobra to use these additional fields.
N/A
VAC This column displays the Variance At Complete in dollars.

BAC - EAC

VAC % This column displays the Variance At Complete percentage.

((BAC - EAC) / BAC) * 100

Variance This column displays the Variance.

Budget - Actuals

Work Package This column displays the work package ID. N/A
Work Package Codes [1-9] This column displays the work package codes assigned to the project. N/A
Work Package Manager This column displays the work package manager assigned to the project. N/A